OpenEdge Data Management:<br />SQL Reference SQLPStatement.makeNULL

Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLPStatement.makeNULL

Sets the value of an SQL statement’s input parameter to NULL. This method is common to the SQLCursor, SQLIStatement, and SQLPStatement classes. This method is redundant with using the setParam method to set an SQL statement’s input parameter to NULL.

Format

public void makeNULL(int f)

Returns

None

Parameters
f
An integer that specifies which input parameter of the SQL statement string to set to NULL. (1 denotes the first input parameter in the statement, 2 denotes the second, and so on.)

Throws

DhSQLException
Example

This code fragment illustrates SQLPStatement.makeNULL:
CREATE PROCEDURE sps_makeNULL()

BEGIN
     SQLPStatement insert_sfns1 = new SQLPStatement ("INSERT INTO sfns 
      (fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld) 
      values (?,?,?,?,?,?)" );
     insert_sfns1.setParam(1,new Integer(666));
     insert_sfns1.makeNULL(2);
     insert_sfns1.makeNULL(3);
     insert_sfns1.makeNULL(4);
     insert_sfns1.makeNULL(5);
     insert_sfns1.makeNULL(6);
     insert_sfns1.execute();
END 